forum

home / developersection / forums / how use the dispose method for close the connection

Ask Question
Rajesh Goswami

Other

Follow
Can you answer this question?
Answer

4 Answers

Shankar M

Shankar M

25-Feb-2013
Post is removed by the User.
Shankar M

Shankar M

25-Feb-2013
Hi Rajesh,

You don't need to explicitly close the connection that is opened, You can use the Using Clause.

using(SqlConnection sqlcon = new SqlConnection(constring))
  {
   }

The leverage of using it is the resources tied up to it are freed automatically with out explicitly calling the
Dispose() Method.

Thanks,
Shankar
Shankar M

Shankar M

25-Feb-2013
Hi Rajesh,

You don't need to explicitly close the connection that is opened, You can use the Using Clause.

using(SqlConnection sqlcon = new SqlConnection(constring))
  {
   }

The leverage of using it is the resources tied up to it are freed automatically with out explicitly calling the
Dispose() Method.

Thanks,
Shankar
yash Singh

yash Singh

18-Dec-2010

Dispose() method permanently removes connection object from memory and the resource no longer exists for any further          processing.


string constring = "Server=(local);Database=my; User Id=sa; Password=sa";
SqlConnection sqlcon = new SqlConnection(constring);
 sqlcon.Open();   // connection is open

try
{
//  code here which will be execute
}
catch
{
     // code  will be execute when  error occurred in try block
}
finally
{
 sqlcon.Dispose();         // close and desroy the  connection object
}

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy